Search:
Type: Posts; User: fdegree
Search:
Search took 0.02 seconds.
-
Thank you for that suggestion. It looks like it should work. But, after a lot of research, I learned about Regular Expression (regex) and created this code, where the Rnge was defined earlier in the...
-
I am using VS 2008, and coding in VB.Net for an Excel 2007 Add-In.
I am looping through a range of cells and programatically changing the value within the cell. I have the code to accomplish this...
-
That's exactly what I am looking for. Such a simple solution that never occurred to me...as usual.
THANK YOU!!! Sorry for not putting it all out there in the beginning. I'm sure I made this more...
-
Thank you for your input. I truly do appreciate it.
In an attempt to keep things simple, I probably complicated it by only providing what I thought would the bare minimum needed. It appears I am...
-
Thank you for helping....
Your above code does exactly what I want, using VBA.
However, when converting to VB.net, the " Selection " object is not recognized.
The formula part, I think I got...
-
Thank you!
I'll work with this and see what I come up with.
One thing I have noticed.... UsedRange ....seems to return any cell that has data in it. But, what I'm looking for is the code that...
-
Thanks for responding Chris...
1) the User has an Excel workbook open and a certain worksheet....Sheet1
2) the User selects any Range of Cells
3) the User clicks a Button on the custom Ribbon...
-
When I assign the cell range through code and the formula through code, it works just fine. As follows:
Dim rng As Range
Dim cel As Range
rng = ActiveSheet.Range("A1:A10").Cells
For...
-
I am using VS 2008, and coding in VB.Net for an Excel 2007 Add-In.
After the user selects a range of cells, they can open a form where they are asked to enter a custom formula into a text box....
-
I got it to work!
I used Pete's recommendation:
sht.PageSetup.RightFooter = "Page &P of " & PgCnt
I tried this after Pete made the suggestion, and it gave the same results as I...
-
Here is something even more puzzling...
I added this code:
Dim WrkShtPgCnt As Integer
If .pagesetup.pages.count > 1 Then
WrkShtPgCnt =...
-
This is called from a button click event on a custom ribbon.
It's copied from your example, so it is almost identical.
Dim xlWB As Excel.Workbook
Dim j As Integer
...
-
I can't figure out what I'm doing wrong, but I continue to get the exact same results as I described above in post 10.
-
This has been very helpful...I'm making progress. There is one problem I'm having with vbfbryce's code.
If there is a worksheet with more than 1 print page, each print page is given the same page...
-
vbfbryce -- that is working perfectly to count the number of print pages, in the workbook, that are located after the TOC...Thank You! But, it does not change the total page count in the...
-
Thanks for the input, it is truly helpful. I see where that can determine the page count. My vision was to try and find Excels internal total page count, and offset it with code.
Maybe this...
-
I have a workbook that has a Cover Page, and various other worksheets, prior to the Table Of Contents. The first worksheet after the TOC is assigned the page number of "1". I'm using this VB.Net code...
-
Thanks for sharing...I sincerely appreciate it.
-
Yes, I would be curious to see the code...THANKS!
-
Thanks for that suggestion. Maybe I'll play around with this idea.
-
Thank you for that information. That's unfortunate, I was hoping to make this feature more customizable for the user.
-
Thank you for that suggestion...
That code modification is placing the text in the active cell, and it will place the text immediately after any content of the cell, which is certainly an...
-
Using VB.net to create a custom Ribbon in Excel. I am trying to get the text content from a .txt file, and place it in a an Excel cell, without losing any existing content of that cell. So, I think...
-
Thank you! I thought I tried changing <True> to <False>, and didn't see any difference in the behavior of the results. But, I must have been missing something, because it now overwrites the text...
-
I am using VB.net to allow the user to create buttons on the custom Ribbon. These buttons will insert commonly used notes into their report, so the user will not have to rewrite them every time. My...
-
THANK YOU...THANK YOU...THANK YOU!
That worked. Here is the exact code that is working for me:
Dim CVRSheet As Worksheet
CVRSheet =...
-
Thanks westconn1...
When I try to transpose the VBA code .net, here is what I have:
Dim CvrSheet As Worksheet
Dim TOCSheet As Worksheet
CvrSheet =...
-
Thank you 3com for the input. I was truly hoping to simply copy the image from "Sheet1". But, since I was unable to figure that out, I kept working at it until just now finding a solution...
I can...
-
I have continued to work on this, and here is what I have so far...
I recorded a Macro to see how that code looked, and here is that Macro:
Sheets("Sheet1").Select
...
-
I want to insert a picture into cell A1 on a worksheet that is labeled "TOC". This picture can be grabbed from one of 2 places:
The image is currently on the worksheet labeled "Cover"...so I can...
-
I figured it out.
Dim xlWorkSheet As Excel.Worksheet
xlWorkSheet.PageSetup.FirstPageNumber = ...Whatever value you want it to be
-
I have some VB.net code that is generating a table of contents, and depending upon the length of the table contents, determines the page number of the first sheet after the table of contents. In...
-
Excellent information from both of you!
I sincerely appreciate it.
-
Thank you! That also work beautifully!
Does any one have any thoughts about:
What is the likelihood of Microsoft changing the ID numbers in future versions of Excel? Which would obviously make...
-
Thank You! That worked perfectly! This is exactly what I was looking for.
It creates 2 questions in my mind though:
How do you find the ID numbers of each control?
What is the likelihood...
-
I'm using VB.net to create a custom ribbon in Excel. Among other things, I'm trying to place some of our most used functions on this menu, so we don't have to keep bouncing between ribbons.
One of...
-
I am using VS 2008, and coding in VB.Net. I have created an Excel 2007 Ribbon Add-In.
I want a button click event to perform a loop through each cell, in each row, of the active worksheet....
-
I understand. Thanks for your suggestions
-
I may be mistaken here, but I think the first version with Ribbons was Excel 2007. Also, I think, the Ribbon Add-In I'm creating for 2007 will work on any newer version...it certainly is working...
-
I think I understand what you are saying.
Am I wrong in thinking that the ribbon add-in won't work for anything older than Excel 2007, because of the ribbon design changes that occurred in the...
|
Click Here to Expand Forum to Full Width
|