PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 [106] 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Solved: Fully clearing the used range of a worksheet
  2. code error going from xls 2000 to 2007
  3. Solved: Formula For based on blanks
  4. Solved: Count highlighted rows
  5. Change Tracking - possible without custom views?
  6. Need to reference multiple workbooks
  7. Get Key
  8. save as
  9. Solved: combobox populate
  10. VBA codes for skipping cells
  11. Solved: Compile Error of Duplicate Decleration in Current Scope
  12. find duplicates with different data and extract it
  13. Create New Workbook from existing Tab
  14. Solved: Find value, input into a different column
  15. [SLEEPER:] VBA-PERL via .bat
  16. Solved: Importing a .txt file without a user prompt
  17. Multiple Page Print Form
  18. Lots of small queries in a small database - performance problems
  19. Remove string before a certain character
  20. HTML save not working
  21. Help with VBA Excel project please!
  22. Solved: Remember Hidden State
  23. Change font for part of a cell
  24. Combining Multiple Workbooks / Worksheets
  25. Button Image
  26. Solved: save problem
  27. Controlling the number formats in a file
  28. VBA Forms Module Help please.
  29. EnableOutlining problem - It is driving me mad!!
  30. Solved: show very hidden
  31. application not visible flashes
  32. Help with small project for work please
  33. Looking for VBA algorithm for circular references
  34. VBA Excel macros
  35. Create PDF Stopped Working.... Help!
  36. User Form /COMBO BOX 1
  37. Solved: Workbook_Open loop??
  38. Solved: VBA Reference Protected Workbook
  39. Solved: go to vb studio?
  40. Solved: textbox line under the text
  41. Solved: Auto Unique List
  42. Userform to edit records in different sheets
  43. I would like code to show active workbook
  44. Solved: Specifying file location in a cell and referencing to that cell in VBA, ASCII of 0 to
  45. Solved: help with the first program
  46. Avoiding Variants
  47. Excel exported reports have problem
  48. Adding a column to highlight the changes while comparing two version of excel sheet
  49. Solved: Sum if or sumproduct help?!
  50. Solved: values in range
  51. Copying Autofiltered data, pasting all data when autofilter shows no data
  52. Solved: Create dynamic range to use in formula
  53. Hide rows with bold text
  54. Perform action only if mutiple criteria is met
  55. Solved: call windows printers
  56. Sending Email in Excel
  57. VLOOKUP in VBA
  58. Combining mutiple excel files
  59. Copying certain cell on condition
  60. Searching many sheets for data
  61. Using name manager
  62. Solved: displaying certain line of text from notepad
  63. displaying certain line of text from notepad
  64. Trouble with Grouping
  65. Solved: ListBox1.RowSource for visible Rows.
  66. copy cells from one sheet to another
  67. moving folders based on a criteria
  68. Text To Columns VBA
  69. Solved: Form run time
  70. Creating Text Files from excel each row
  71. HOW TO OPEN EXCEL ADD-INS IN TO VIEW CODES
  72. VBA Coding: Font Change
  73. export worksheet to a txt file
  74. Copy rows to new tabs based on value in 1st column
  75. Solved: Cut and Paste cell value between 2columns based on criteria
  76. VBA code for comparing a worksheet with a column and show the result with a color
  77. QR Codes for Excel 2003 XP
  78. insert range of cells if data in column doesn't match
  79. Copy and Paste Problem
  80. Workbook_BeforeSave
  81. Solved: VBA to auto email report
  82. run macro automatically based on criteria in other spreadsheet
  83. Fixed/non volatile date function
  84. Copy between sheets
  85. Solved: average offset rows in a column
  86. Macro to update Sheet2 based on Sheet1
  87. Indentify column references for cells that meet criteria and assign them to variable
  88. Solver VBA reference in non-english Excel
  89. Solved: textbox focus
  90. combobox one last push
  91. create log for entire file
  92. Solved: I have exceeded Excel’s limit of 1048576 rows while importing data from a file
  93. [SOLVED:] Timeformat Sum Up and Separation Based on Conditions
  94. Cell reference copy in another cell without link and formula
  95. Object required error with VBA rows deleting
  96. Formula solution for repeated search in column
  97. Solved: Copy selected range in autofilter
  98. Insert the name of the worksheet in cell and than link the cell to another worksheet
  99. Count If
  100. Update powerpoint from excel macro
  101. Excel VBA Macro Crashing
  102. Solved: if & vlookup formula : help requried
  103. Disable alert message
  104. pulling data from multiple worksheets
  105. Select Case Function
  106. problem inserting formula with R1C1
  107. Run Time Error 7
  108. UserForm_Terminate
  109. Sub / Function recorder
  110. New project
  111. Spreadsheet data management
  112. Solved: Find and Replace for Time
  113. Do Loop with InputBox and ActiveCell Ref HELP!!
  114. Solved: AutoFill TextBox in UserForm
  115. Sleeper: Highlighting Cell in Variant
  116. Solved: web navigation
  117. looking for an Event that fires when an existing Workbook is opened
  118. Opening Excel file and running macro
  119. How to save filename with -v2 -v3 and so on at the end if file name already exists
  120. Solved: Turning multiple quantities into singles
  121. Referring to excel application
  122. Solved: Trouble looping through ranges with non-adjacent cells
  123. Automating calculations between values on 2 separate worksheets
  124. VBA knowing which cells it has filled?
  125. Combine "if" formula : help required
  126. Bulk Copy / Pasting
  127. Automatically fill cell when data entered in another sheet
  128. Macro crashing excel
  129. Please help me find out the data link of the website
  130. Subtracting Values of Range Variants
  131. Status Bar or Progress Bar
  132. Solved: Concatenation of many cells from another workbook as a “block text”?
  133. Filtering the values and removing the duplicates
  134. Solved: OLECMDID_SAVE or SAVEAS pvain pvaout
  135. Parsing an RFP Word Documnet to Excel
  136. help with code please for arrays
  137. Reset MOST of Worksheet with Macro
  138. Graph in VBA
  139. auto save workbook upon close
  140. Solved: filter bloks
  141. Solved: ChangePivotCache - PivotCaches.Create Problems
  142. How to Loop through columns in an Array and write to a range
  143. Add additional data to word document's bookmark in excel
  144. Solved: Subtotal() generates extra lines
  145. File Copying From/to different Folders
  146. Solved: Downloading File issues - Buffer Length invalid or not enough memory
  147. Text to Excel VBA
  148. How to show save as dailog box
  149. Solved: macro to read a cell and subtract a number?
  150. How can I display a list of folders and files in window?
  151. error when puting more than 1 string
  152. Help on Extract portion of string in the right way
  153. need to help: mid function
  154. Move data from Excel 2007 to Access 2007 using VBA
  155. Copying last value of a column
  156. Impoting excel sheet to new workbook
  157. date help
  158. Solved: If values in row cut/paste
  159. If the selected cell does not have a comment, then insert a comment.
  160. Ways of declaring arrays
  161. Changing Multiple For Each Statements Together with Next - VBA
  162. Solved: leave the ActiveX text box, pressing 'Enter'
  163. Data Feed to Excel using XML from a website
  164. Formating prob
  165. Select dates by current month
  166. first post....
  167. Unable to get the Vlookup property of the WorksheetFunction class
  168. VBA Nested Lookup as a UDF
  169. Solved: VBA count files funtion
  170. Solved: How to repeat a procedure/code a number of times
  171. Solved: Return which control triggered an AfterUpdate event
  172. Autonumbering invoice then saved to another worksheet in the same workbook
  173. HTML Source Code from Safari/Mozilla on mac
  174. Build a tree of called functions / procedures
  175. Adjusting array of values for filtering for actual values in sheet
  176. Saving file
  177. VBA for Updating Pivot Table report filters from a OLAP Cube
  178. Form Display stops at FormName.Show - Why
  179. Solved: Whenever cell is added will be recorded on another sheet with date and time and value
  180. Copy a cell from excel to word and aligning center using VBA
  181. how to make add-in load before workbook
  182. HTML Source from IE
  183. Solved: Delete Rows with Condition
  184. excel 2007 cell context menu question
  185. Solved: Array Not Working
  186. Solved: Get Textbox Value
  187. Help with macro to update text on shapes
  188. Solved: Select the cell with the click of a mouse, and have the result of calculation
  189. Solved: How to get Last Key or Key-Combo Pressed (Not Event)
  190. Solved: Moving files from different source folder to different destination folders
  191. Solved: Parsing Addresses
  192. Help with Macro and Object Variable
  193. Pull info from one Active Workbook and Save in Another
  194. Solved: If wb is open give message
  195. exe
  196. UK National Insurance Number Validation
  197. data conversion
  198. Solved: VBA to create a separate sheet for each month
  199. Right click option menu...specific items
  200. Invoice Processing
  201. Input difference words run difference macro in one textbox
  202. Open XML file in Notepad and delete all "-"es
  203. Solved: Hiding columns
  204. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
  205. display worksheet data in user form
  206. Convert sub to function - prompt not appearing in formula bar
  207. Solved: Print pages that contain data
  208. Solved: Increment Formula With If Statement
  209. Boost Macro running speed
  210. group data
  211. [SOLVED:] Removing Duplicates for Multiple Columns independently
  212. Solved: Report to collect filtered data from multiple sheets and consolidate
  213. Hide columns based on cell value
  214. Copy from one worksheet and save to another
  215. Solved: Lastrow +
  216. Validating more than one textbox for Null values
  217. Solved: Sum particular data
  218. Solved: Simple VB? Take one file and make many
  219. HTTPS GET REQUEST ***HELP***
  220. Passing variables
  221. VBA code to send excel sheet as PDF
  222. Combining MsgBoxes into one box
  223. Userform limit?
  224. Solved: how to make shipping label with picture
  225. Find 1st Empty Cell in Range
  226. Formating (pivot)
  227. Want to create a variable that references a cell
  228. How to copy and paste the date
  229. Force ontime Macros to run one after another instead of simultaneously
  230. Solved: Move to Next Record
  231. Solved: Moving cell values based on specific criteria
  232. VBA code for Cursor to stay Stationary in one cell
  233. Automatic Calculation when sheet tab clicked
  234. SaveCopyAs not working.
  235. Urgent VBA Debugging help
  236. Concatenate string with itself in a "while" loop
  237. MultiPage in UserForm
  238. How can I change part of my title by referencing a value in a cell?
  239. Create Desktop Shortcut - Change Icon
  240. Flag on birthday calendar
  241. Solved: Macro request: Copy rows that match values in a column of names
  242. excel 2010 windows 7 64 bit hangs fooooorever
  243. Saving a file vy referencing a cell and using RDB Create
  244. Solved: Round down to nearest 5,000
  245. Solved: Cell value = #NUM!
  246. Solved: Code wont run in certain modules
  247. Solved: UserForm with ComboBoxes and TextBoxes
  248. Loop to Copy Text From Excel to Powerpoint Text Boxes
  249. Solved: How to activate the cells by using VBA
  250. A lending hand to PDF FDF