Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 11 of 11
Search took 0.01 seconds.
Search: Posts Made By: onexmadxdisaster
Forum: Excel VBA October 25th, 2017, 01:30 PM
Replies: 8
Views: 837
Posted By onexmadxdisaster
I appreciate you at least reading all my...

I appreciate you at least reading all my questions! I have multiple macros I am writing for multiple projects, and I keep hitting these little road blocks!
I am trying to get through the entire 24...
Forum: Excel VBA October 25th, 2017, 01:24 PM
Replies: 8
Views: 837
Posted By onexmadxdisaster
Unfortunately the string will vary in length and...

Unfortunately the string will vary in length and structure, which is why this is so complicated... I am pulling a range of data from a separate program, "attachmate" and it pastes it all into one...
Forum: Excel VBA October 23rd, 2017, 05:22 PM
Replies: 8
Views: 837
Posted By onexmadxdisaster
Find text within a cell, and pull four characters previous

Howdy again folks!
I am looking to have a macro take a string of random text, find a specific word in it (which will not always be in the same place) and IF it finds it, to return the characters in...
Forum: Excel VBA October 16th, 2017, 03:20 PM
Replies: 5
Views: 904
Posted By onexmadxdisaster
I think I figured it out! I am so happy! I used...

I think I figured it out! I am so happy!
I used different subs in the same module like you had outlined, but I moved my Dim statements for my variables to the beginning after Option Explicit, but...
Forum: Excel VBA October 16th, 2017, 02:41 PM
Replies: 5
Views: 904
Posted By onexmadxdisaster
I am following that code for the most part... I...

I am following that code for the most part...
I think I am still going to run into the issue of my variables not being defined in all Subs/Modules no matter how I do it. Can you define things...
Forum: Excel VBA October 11th, 2017, 01:09 PM
Replies: 5
Views: 904
Posted By onexmadxdisaster
Procedure too large

I am trying to write a macro to audit account data. I will have headers for all of my fields in each column, and each account data in the rows below, and I am writing my macro to go through each row...
Forum: Excel VBA October 11th, 2017, 12:11 PM
Replies: 11
Views: 4,470
Posted By onexmadxdisaster
ohhhh I see.... So with the immediate window...

ohhhh I see.... So with the immediate window pulling and temporarily storing data, can you call on the data in the immediate window too?
Forum: Excel VBA October 10th, 2017, 04:28 PM
Replies: 11
Views: 4,470
Posted By onexmadxdisaster
Wonderful! Thank you SOOO much Zakalwe! [:D] I...

Wonderful! Thank you SOOO much Zakalwe! [:D]
I am definitely trying to compile and debug as often as I can, but I keep getting personal roadblocks in determining what the specific issue is.
Do you...
Forum: Excel VBA October 10th, 2017, 01:19 PM
Replies: 11
Views: 4,470
Posted By onexmadxdisaster
Okay, my code is a little bit better now. Here is...

Okay, my code is a little bit better now. Here is the entire sub. Still stuck...

Sub MarkAccountNumber()
'Auto fit width on all columns

Range("A:A, DA:DA").EntireColumn.AutoFit

' Find...
Forum: Excel VBA October 10th, 2017, 12:52 PM
Replies: 11
Views: 4,470
Posted By onexmadxdisaster
I already have the code for white as RGB (255,...

I already have the code for white as RGB (255, 255, 255), and the gray color I want is RGB (166, 166, 166) but I can't figure out the code... This is all I can think of so far....

If *any cell...
Forum: Excel VBA October 10th, 2017, 12:06 PM
Replies: 11
Views: 4,470
Posted By onexmadxdisaster
If cell is any color then...

Howdy all.
This is my first time posting, and I am very beginner level so bear with me....
I am trying to write code that says if any of the cells between B1 and D1 are filled with ANY color, then...
Showing results 1 to 11 of 11

 


All times are GMT -4. The time now is 06:37 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.